create procedure [dbo].[BAEImisOrderbadgeInsert] @ORDER_NUMBER as
float,
    @BADGE_NUMBER AS int,
    @BADGE_TYPE AS varchar(10),
    @FULL_NAME AS varchar(60),
    @TITLE AS varchar(80),
    @COMPANY AS varchar(80),
    @FULL_ADDRESS AS varchar(255),
    @PREFIX AS varchar(10),
    @FIRST_NAME AS varchar(20),
    @MIDDLE_NAME AS varchar(20),
    @LAST_NAME AS varchar(30),
    @SUFFIX AS varchar(10),
    @DESIGNATION AS varchar(20),
    @INFORMAL AS varchar(20),
    @ADDRESS_1 AS varchar(40),
    @ADDRESS_2 AS varchar(40),
    @CITY AS varchar(40),
    @STATE_PROVINCE AS varchar(15),
    @ZIP AS varchar(10),
    @COUNTRY AS varchar(25),
    @BAR_CODE AS varchar(14),
    @DELEGATE AS varchar(10),
    @ST_PRINT_COMPANY AS bit,
    @ST_PRINT_TITLE AS bit
AS
    INSERT INTO Order_Badge
    (
    ORDER_NUMBER,
    BADGE_NUMBER,
    BADGE_TYPE,
    FULL_NAME,
    TITLE,
    COMPANY,
    FULL_ADDRESS,
    PREFIX,
    FIRST_NAME,
    MIDDLE_NAME,
    LAST_NAME,
    SUFFIX,
    DESIGNATION,
    INFORMAL,
    ADDRESS_1,
    ADDRESS_2,
    CITY,
    STATE_PROVINCE,
    ZIP,
    COUNTRY,
    BAR_CODE,
    DELEGATE,
    ST_PRINT_COMPANY,
    ST_PRINT_TITLE
    )
    VALUES
    (
    @ORDER_NUMBER,
    @BADGE_NUMBER,
    @BADGE_TYPE,
    @FULL_NAME,
    @TITLE,
    @COMPANY,
    @FULL_ADDRESS,
    @PREFIX,
    @FIRST_NAME,
    @MIDDLE_NAME,
    @LAST_NAME,
    @SUFFIX,
    @DESIGNATION,
    @INFORMAL,
    @ADDRESS_1,
    @ADDRESS_2,
    @CITY,
    @STATE_PROVINCE,
    @ZIP,
    @COUNTRY,
    @BAR_CODE,
    @DELEGATE,
    @ST_PRINT_COMPANY,
    @ST_PRINT_TITLE
    
);

GO